﻿select 
	m.MediaObjectId
	,a.directoryName 
	,m.OriginalFilename as FileName
	,m.ExternalHtmlSource
from Gs_Album a, Gs_MediaObject m 
where a.albumid = m.fkalbumid and a.albumid = @albumId